package pe.edu.upc.jtigers.svpn.data.queryable;

public final class UsuarioQueryable {

	public final static String LOGUEAR = "SELECT u FROM Usuario u WHERE u.correoElectronico = :correoElectronico and u.contrasena=:contrasena and u.eliminado =0";

	public final static String VALIDA = "SELECT u FROM Usuario u WHERE u.correoElectronico = :correoElectronico or u.numDocumento = :numDocumento";

	public final static String BUSCAR = "SELECT u FROM Usuario u WHERE "
			+ "(u.correoElectronico like :correoElectronico or ''= :correoElectronico) and "
			+ "(u.numDocumento like :numDocumento or '' = :numDocumento) and "
			+ "(u.nombres like :nombres or '' = :nombres) and "
			+ "(u.apePaterno like :apePaterno or '' = :apePaterno) and "
			+ "u.eliminado =0 and tipoUsuario = :tipoUsuario";
	
}
